UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xYF7FKqDy9qzpnyGkFeWaIx+uFSaNjWcBcGpm9Bamrg='
WHERE
key_id = '9b3d80848d3a8c11722687285c19f99792f5404fec99bd3ae1587c40a547de1b'
AND (
token = 'xYF7FKqDy9qzpnyGkFeWaIx+uFSaNjWcBcGpm9Bamrg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)