UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'yk6QESFuKjeMLvSwZ3AylTta9Ma3rc98xIfW4sMj1wk=' 
WHERE 
  key_id = '7709d50dcdf7a0bd8c9798933a39af85396d3c00fff22c8ac7ce5d31e39d3bd2' 
  AND (
    token = 'yk6QESFuKjeMLvSwZ3AylTta9Ma3rc98xIfW4sMj1wk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028