SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '1a6b5601685731f539e2aead65c62508e4f29c7a0e49da6588ae01a608c44933' 
  AND token = '9JyHy3RfiHcy9X0I+B0jcDD4sawYFfce/FXQPPdH7Ko=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00024

JSON explain

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