SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'b7301dd78982d5ec67ccaa64f6c49d0fc542e0628d92d14171de884f5ecaea55' 
  AND token = 'SE4111joTQJrMJH0rn3L+cqteHBz9z+NZDR12va7Auo=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00017

JSON explain

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