UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C4EuwzHPeGnHPCGFQ98tjF2M8HiGlL53lm9u9wz3AUY='
WHERE
key_id = 'a1b9292136796898a3d2cc2116db9802c25cf989696564af2aa49ffec4677a04'
AND (
token = 'C4EuwzHPeGnHPCGFQ98tjF2M8HiGlL53lm9u9wz3AUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)