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