SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '330466bb6041dfd15d2d9ff9ed0916e7fe007b54b9502a94e62faa080148375d' 
  AND token = 'UwCGFzF0copl/98B8fweqlMS2WnZD2Fxpv+oxyXbHm8=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00017

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}