UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MTKTgB2vY9+uVbMoph17XnkallXNLV5warqrLKKnAQo='
WHERE
key_id = '940d3b7fc47c513171da2902e2647bebec96fb2f912b6847c58ee48be88ff34b'
AND (
token = 'MTKTgB2vY9+uVbMoph17XnkallXNLV5warqrLKKnAQo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)