UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7qN2h/G6pIWT8OgmkQ2oAxX58YgbyahkKP6oE6tYJew='
WHERE
key_id = 'ae10d102b17c00df44b89d0d8b4b621f176e7a993900f84b7f5a03acc94586e4'
AND (
token = '7qN2h/G6pIWT8OgmkQ2oAxX58YgbyahkKP6oE6tYJew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)