UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A0xGx7zMyg4Y1DZCyFdd/11SGllp1XscLEXgUTMuROw='
WHERE
key_id = 'c711022c9ef50cb6ae510b13793f6637d3c43e64c043b92a0dce54f2ed500165'
AND (
token = 'A0xGx7zMyg4Y1DZCyFdd/11SGllp1XscLEXgUTMuROw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)