UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iC7XcZjG06oXdMtLFz1SqPqD65ppRV4IrtKYc4MB9Kw='
WHERE
key_id = '89957f4df5a0ea75f0e46a6bff31603a1846cdb4d1a84beface09f388b92d724'
AND (
token = 'iC7XcZjG06oXdMtLFz1SqPqD65ppRV4IrtKYc4MB9Kw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)