UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U9oqVurXhBS77FLRB8QEfivNkOla5xhprbz2FYvnunU='
WHERE
key_id = '2330aad00d3698de3820f8de6f3970d2bb59d5a70704f7e6ddba479862f8b60a'
AND (
token = 'U9oqVurXhBS77FLRB8QEfivNkOla5xhprbz2FYvnunU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)