UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o8PPmV/SvRlZRz27MCNAS0bjeudO/2g7JQliIS5w11g='
WHERE
key_id = 'f60bac23204b90f09c046abe614230407dc75132a789a0f6ff298d25b09d94d5'
AND (
token = 'o8PPmV/SvRlZRz27MCNAS0bjeudO/2g7JQliIS5w11g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)