UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H9KNKo7nqzRADEsWs8KbQCoJhprlbX8t0k0CDtedGCg='
WHERE
key_id = 'ee47150a68d9b857f8d023a45b02ad7d52ec452529fc46657d1aaa3c591d23e4'
AND (
token = 'H9KNKo7nqzRADEsWs8KbQCoJhprlbX8t0k0CDtedGCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)