UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sxsTWSvhDq8DYhXsF5zFPQIYkDCVqw28geLRc1pxcK4='
WHERE
key_id = '59df828c98cc24ee0e8305bf1a961be73e02f7f1f5c34d41f1adfae2ac326322'
AND (
token = 'sxsTWSvhDq8DYhXsF5zFPQIYkDCVqw28geLRc1pxcK4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)