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