UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7jkCecECiNaTeQv1farMnWKeuZYy0wZodK4flFFmrcg='
WHERE
key_id = '5d242cb24bc5e88fe508fc2951ed0a0488948525b6cce547cb47353c972cfb10'
AND (
token = '7jkCecECiNaTeQv1farMnWKeuZYy0wZodK4flFFmrcg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)