UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z4WCisc5KVCdU2VEjE6dQmiCtLsZc/2/siVyZRGY/Gc='
WHERE
key_id = 'aadb334768ecd4ca086a512e00b305e76608b2a1061c05704583170caf17e557'
AND (
token = 'Z4WCisc5KVCdU2VEjE6dQmiCtLsZc/2/siVyZRGY/Gc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)