UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pVjmOi0NHL5c6NmUyZyOz0NVRIYZfmuzQV8aLiYIj3c='
WHERE
key_id = 'df1cf951406f5e9b43546aa50a7e9b9e1249120372d1e80e14d35ce0a4ba7097'
AND (
token = 'pVjmOi0NHL5c6NmUyZyOz0NVRIYZfmuzQV8aLiYIj3c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)