UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cqMX4KnVd50YlFt2zQPkw1PxoMlkx2PItMSRMEF8NN8='
WHERE
key_id = 'd1843533aabdaf6a69ee045de14d0cce009b4fea789caf3302733a7ed5c088c4'
AND (
token = 'cqMX4KnVd50YlFt2zQPkw1PxoMlkx2PItMSRMEF8NN8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)