SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'e27000afbf964082aa29f7235521d71da8dec63479ff18cfd304e2e10fc757f6' 
  AND token = 'Wd3amcl1A+xSB27IxJS0U7Os0hH0W9CC5e+jk066F2M=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00029

JSON explain

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