UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hi6KIt6cdyROuowrtTjOzNIA2gWhUH/iuOjeEhpC6oQ='
WHERE
key_id = '9005ecfe3e78926b27589f9a827188fa45a861f9b7ddc7245c973e73dca20c11'
AND (
token = 'hi6KIt6cdyROuowrtTjOzNIA2gWhUH/iuOjeEhpC6oQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)