UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'wNGajAgG/MK1f1LyJI7XT/vc8hMzI+jB7IoCgjxh1Ws=' 
WHERE 
  key_id = 'de2dcabd3e41cb95b3ebc8c0dda0eb955e5413f240d2667dbdcb6e9b3d190a46' 
  AND (
    token = 'wNGajAgG/MK1f1LyJI7XT/vc8hMzI+jB7IoCgjxh1Ws=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035