UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fwwSGo94dr/1lJhs9Qzs45oOLIszld34An+mMFSErgE='
WHERE
key_id = 'a1200d5772a5da51180bdee185846ea940d0491bca3ae324af1e2e1dbe129a11'
AND (
token = 'fwwSGo94dr/1lJhs9Qzs45oOLIszld34An+mMFSErgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)