UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FQV5yzJzQaBJk+VRise+zHSMW/2i7rHV+Rwev3e7zjM='
WHERE
key_id = '99a6c9287840f35ed0a456e01b88282632be6ed300b567655ff6a47a1bd8420d'
AND (
token = 'FQV5yzJzQaBJk+VRise+zHSMW/2i7rHV+Rwev3e7zjM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)