UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zBkO9KKe6swHOusiBoP4w6HzpF7AJBtW4msLEbp15qg='
WHERE
key_id = '57ad30c2e40919ec6c9e3cd063926da313c975761e13a2b2919f51dd0b48ae43'
AND (
token = 'zBkO9KKe6swHOusiBoP4w6HzpF7AJBtW4msLEbp15qg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)