UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D6ltnskJnbq3z/Md1N4kgzxX5ootjabKb9udrvk8Ws0='
WHERE
key_id = 'ecd56148789aa48d4998eded43655ee0bf7dabfb7d2d9005e893358cd9573734'
AND (
token = 'D6ltnskJnbq3z/Md1N4kgzxX5ootjabKb9udrvk8Ws0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)