UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rEIl0Ozq9zVVnW0cdwPi02s496UtXh9l6B/fzO4AHxg='
WHERE
key_id = '9efaa6e37ab767a5024c8dd647a0fc8bfa3dd05fbbb3e00e2f7309d8bc1d9b72'
AND (
token = 'rEIl0Ozq9zVVnW0cdwPi02s496UtXh9l6B/fzO4AHxg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)