SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '152db41b6acb2f8249ca27870730fdc975f2ac08d29f2b172774dee03b8934d0' 
  AND token = '1jPktzaBwPBS9z9qtp9gIgzfBOEXa2Mt7mV33gSD1v8=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00023

JSON explain

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