UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8qhyRN8zUZIpid6kwY7i2qJXCxpJv3aL0n+f+orgjQc='
WHERE
key_id = '5235481b61867e2960bb2dabf46f0b6329a414f54af7a98590e80080e54fa7ee'
AND (
token = '8qhyRN8zUZIpid6kwY7i2qJXCxpJv3aL0n+f+orgjQc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)