UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EDefIK5keMfJ7jZJaJyJzHvvBuTXA4AtdToKKOj7+xk='
WHERE
key_id = '9ff38577393c457d30d2fbf8d90ed70ec75f642b15ae62c8a5a5b4cb10324579'
AND (
token = 'EDefIK5keMfJ7jZJaJyJzHvvBuTXA4AtdToKKOj7+xk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)