UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BsyF26lWwtjh5ib84oGF7gxUsv+oYprVKJoh7sHTH+0='
WHERE
key_id = 'cc1f414d8bb3dbb77ce0504cf7f8d40aef153e7f4bae7b5c8cde3bb8aa29f299'
AND (
token = 'BsyF26lWwtjh5ib84oGF7gxUsv+oYprVKJoh7sHTH+0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)