UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SpogtDKAmRqmAw0TfrzsDEglr6CgPyyq6UMH6eccS3Y='
WHERE
key_id = '28af048ffa78b33598a83464cc4eb2f96c97e35523edc34691210971fb68ab7c'
AND (
token = 'SpogtDKAmRqmAw0TfrzsDEglr6CgPyyq6UMH6eccS3Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)