SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '13dd102f08975a60dbf7b3701ac10c5ce13544cdd2af5f51c6f8725a35267eca' 
  AND token = 'w8LQTN4dakQ0NEtYnfSjlR9L98KLn/Ohp2cMtmTCvKs=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00023

JSON explain

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