UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6+2iVIJshpBcNszCC4xlkFu2FCk82Ywnu2HvsH0jlD4='
WHERE
key_id = '80472901881bb1b3ab546bf67d833c7c7abde833a294f7e794406b450e4d073c'
AND (
token = '6+2iVIJshpBcNszCC4xlkFu2FCk82Ywnu2HvsH0jlD4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)