UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o8OngSHq/DKtcJbzj6CXGQxzqHkncOgILv+7Ycf4kl8='
WHERE
key_id = 'a6d4e9be7605e052f71446dc245561c4cc4c3055e558ea5bfd9487d51a16ea37'
AND (
token = 'o8OngSHq/DKtcJbzj6CXGQxzqHkncOgILv+7Ycf4kl8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)